---
title: DB-CLL-061 — Check referential-integrity blockers before delete
summary: Check referential-integrity blockers before delete
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-061 — Check referential-integrity blockers before delete

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-061 |
| Operation type | R |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsLegalPerson.CanDeleteLegalPerson |
| Criteria property | n/a (custom method) |
| Lifecycle method | n/a |

## Parameters

| Name | Direction | Type | Default | Description |
|---|---|---|---|---|
| LegalPersonID | Input | NUMBER | N/A | Legal person identifier reused across all three UNION branches |

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [ATTORNEY_CONFLICT](../database-tables.md#attorney_conflict) | SELECT | ATTORNEY_LEGAL_PERSON_SEQ_NUM |
| [OUTCOME_STAFF](../database-tables.md#outcome_staff) | SELECT | OUTCOME_STAFF_PERSON_SEQ_NUM |
| [LEGAL_PERSON_TYPE](../database-tables.md#legal_person_type) | SELECT | LEGAL_PERSON_SEQ_NUM |

## Sample SQL

```sql
Select
  Count(*)
From
  (
  Select
    ATTORNEY_LEGAL_PERSON_SEQ_NUM
  From
    ATTORNEY_CONFLICT
  Where
    ATTORNEY_CONFLICT.ATTORNEY_LEGAL_PERSON_SEQ_NUM = :LegalPersonID
  Union All
  Select
    OUTCOME_STAFF_PERSON_SEQ_NUM
  From
    OUTCOME_STAFF
  Where
    OUTCOME_STAFF.OUTCOME_STAFF_PERSON_SEQ_NUM = :LegalPersonID
  Union All
  Select
    LEGAL_PERSON_SEQ_NUM
  From
    LEGAL_PERSON_TYPE
  Where
    LEGAL_PERSON_TYPE.LEGAL_PERSON_SEQ_NUM = :LegalPersonID
  )
```

## Operations and processes

- [Manage attorney and legal-person reference data](../operations/manage-attorney-and-legal-person.md)

## Business rules

- [BR-CLM-LGL-006](../business-rules.md#br-clm-lgl-006-attorney-policy-assignment-requires-a-valid-policy)
- [BR-CLM-LGL-007](../business-rules.md#br-clm-lgl-007-attorney-policy-assignment-requires-a-primary-attorney)
- [BR-CLM-LGL-008](../business-rules.md#br-clm-lgl-008-attorney-profile-requires-attorney%2C-type%2C-and-valid-date-range)
- [BR-CLM-LGL-009](../business-rules.md#br-clm-lgl-009-duplicate-attorney-profile-rows-are-rejected)
- [BR-CLM-LGL-010](../business-rules.md#br-clm-lgl-010-attorney-schedule-entry-requires-attorney%2C-reason%2C-and-duration)
- [BR-CLM-LGL-011](../business-rules.md#br-clm-lgl-011-attorney-schedule-dates-must-be-valid-and-non-past)
- [BR-CLM-LGL-014](../business-rules.md#br-clm-lgl-014-legal-person-requires-last-and-first-name)
- [BR-CLM-LGL-015](../business-rules.md#br-clm-lgl-015-legal-person-cannot-be-deleted-while-referenced)
- [BR-CLM-LGL-016](../business-rules.md#br-clm-lgl-016-legal-person-type-link-requires-person-and-type-code)
- [BR-CLM-LGL-017](../business-rules.md#br-clm-lgl-017-other-firm-state-city-must-be-valid)
- [BR-CLM-LGL-018](../business-rules.md#br-clm-lgl-018-out-of-town-rotation-assignment-dates-must-be-valid-and-non-past)

> **Note:** Statements marked with `*` were inferred from code structure, naming
> conventions, or contextual evidence where direct confirmation was not available
> in source artifacts. Statements marked with `**` could not be confirmed; treat
> as unknown until verified.

## Sources

- `SAIF.Business.Claim.Legal\TableMaint\clsLegalPerson.vb`